package com.zj.fx.model.month;

import cn.hutool.core.util.StrUtil;

import java.util.ArrayList;
import java.util.List;

/**
 * 月度结果明细表（部门审核得分明细） MonthResultDtlExample
 *
 * @author SQL_自动生成
 * @date 2023-06-26 17:54:52
 */
public class MonthResultDtlExample {

    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public MonthResultDtlExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }


        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("id like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }


        public Criteria andFkTaskIdIsNull() {
            addCriterion("fk_task_id is null");
            return (Criteria) this;
        }

        public Criteria andFkTaskIdIsNotNull() {
            addCriterion("fk_task_id is not null");
            return (Criteria) this;
        }

        public Criteria andFkTaskIdEqualTo(String value) {
            addCriterion("fk_task_id =", value, "fkTaskId");
            return (Criteria) this;
        }

        public Criteria andFkTaskIdNotEqualTo(String value) {
            addCriterion("fk_task_id <>", value, "fkTaskId");
            return (Criteria) this;
        }

        public Criteria andFkTaskIdGreaterThan(String value) {
            addCriterion("fk_task_id >", value, "fkTaskId");
            return (Criteria) this;
        }

        public Criteria andFkTaskIdGreaterThanOrEqualTo(String value) {
            addCriterion("fk_task_id >=", value, "fkTaskId");
            return (Criteria) this;
        }

        public Criteria andFkTaskIdLessThan(String value) {
            addCriterion("fk_task_id <", value, "fkTaskId");
            return (Criteria) this;
        }

        public Criteria andFkTaskIdLessThanOrEqualTo(String value) {
            addCriterion("fk_task_id <=", value, "fkTaskId");
            return (Criteria) this;
        }

        public Criteria andFkTaskIdLike(String value) {
            addCriterion("fk_task_id like", value, "fkTaskId");
            return (Criteria) this;
        }

        public Criteria andFkTaskIdNotLike(String value) {
            addCriterion("fk_task_id not like", value, "fkTaskId");
            return (Criteria) this;
        }

        public Criteria andFkTaskIdIn(List<String> values) {
            addCriterion("fk_task_id in", values, "fkTaskId");
            return (Criteria) this;
        }

        public Criteria andFkTaskIdNotIn(List<String> values) {
            addCriterion("fk_task_id not in", values, "fkTaskId");
            return (Criteria) this;
        }

        public Criteria andFkTaskIdBetween(String value1, String value2) {
            addCriterion("fk_task_id between", value1, value2, "fkTaskId");
            return (Criteria) this;
        }

        public Criteria andFkTaskIdNotBetween(String value1, String value2) {
            addCriterion("fk_task_id not between", value1, value2, "fkTaskId");
            return (Criteria) this;
        }


        public Criteria andTypeIdIsNull() {
            addCriterion("type_id is null");
            return (Criteria) this;
        }

        public Criteria andTypeIdIsNotNull() {
            addCriterion("type_id is not null");
            return (Criteria) this;
        }

        public Criteria andTypeIdEqualTo(String value) {
            addCriterion("type_id =", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdNotEqualTo(String value) {
            addCriterion("type_id <>", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdGreaterThan(String value) {
            addCriterion("type_id >", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdGreaterThanOrEqualTo(String value) {
            addCriterion("type_id >=", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdLessThan(String value) {
            addCriterion("type_id <", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdLessThanOrEqualTo(String value) {
            addCriterion("type_id <=", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdLike(String value) {
            addCriterion("type_id like", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdNotLike(String value) {
            addCriterion("type_id not like", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdIn(List<String> values) {
            addCriterion("type_id in", values, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdNotIn(List<String> values) {
            addCriterion("type_id not in", values, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdBetween(String value1, String value2) {
            addCriterion("type_id between", value1, value2, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdNotBetween(String value1, String value2) {
            addCriterion("type_id not between", value1, value2, "typeId");
            return (Criteria) this;
        }


        public Criteria andDeptIdIsNull() {
            addCriterion("dept_id is null");
            return (Criteria) this;
        }

        public Criteria andDeptIdIsNotNull() {
            addCriterion("dept_id is not null");
            return (Criteria) this;
        }

        public Criteria andDeptIdEqualTo(String value) {
            addCriterion("dept_id =", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotEqualTo(String value) {
            addCriterion("dept_id <>", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdGreaterThan(String value) {
            addCriterion("dept_id >", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdGreaterThanOrEqualTo(String value) {
            addCriterion("dept_id >=", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdLessThan(String value) {
            addCriterion("dept_id <", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdLessThanOrEqualTo(String value) {
            addCriterion("dept_id <=", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdLike(String value) {
            addCriterion("dept_id like", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotLike(String value) {
            addCriterion("dept_id not like", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdIn(List<String> values) {
            addCriterion("dept_id in", values, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotIn(List<String> values) {
            addCriterion("dept_id not in", values, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdBetween(String value1, String value2) {
            addCriterion("dept_id between", value1, value2, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotBetween(String value1, String value2) {
            addCriterion("dept_id not between", value1, value2, "deptId");
            return (Criteria) this;
        }


        public Criteria andScoreIsNull() {
            addCriterion("score is null");
            return (Criteria) this;
        }

        public Criteria andScoreIsNotNull() {
            addCriterion("score is not null");
            return (Criteria) this;
        }

        public Criteria andScoreEqualTo(String value) {
            addCriterion("score =", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotEqualTo(String value) {
            addCriterion("score <>", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreGreaterThan(String value) {
            addCriterion("score >", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreGreaterThanOrEqualTo(String value) {
            addCriterion("score >=", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreLessThan(String value) {
            addCriterion("score <", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreLessThanOrEqualTo(String value) {
            addCriterion("score <=", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreLike(String value) {
            addCriterion("score like", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotLike(String value) {
            addCriterion("score not like", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreIn(List<String> values) {
            addCriterion("score in", values, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotIn(List<String> values) {
            addCriterion("score not in", values, "score");
            return (Criteria) this;
        }

        public Criteria andScoreBetween(String value1, String value2) {
            addCriterion("score between", value1, value2, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotBetween(String value1, String value2) {
            addCriterion("score not between", value1, value2, "score");
            return (Criteria) this;
        }


        public Criteria andFullMarkIsNull() {
            addCriterion("full_mark is null");
            return (Criteria) this;
        }

        public Criteria andFullMarkIsNotNull() {
            addCriterion("full_mark is not null");
            return (Criteria) this;
        }

        public Criteria andFullMarkEqualTo(String value) {
            addCriterion("full_mark =", value, "fullMark");
            return (Criteria) this;
        }

        public Criteria andFullMarkNotEqualTo(String value) {
            addCriterion("full_mark <>", value, "fullMark");
            return (Criteria) this;
        }

        public Criteria andFullMarkGreaterThan(String value) {
            addCriterion("full_mark >", value, "fullMark");
            return (Criteria) this;
        }

        public Criteria andFullMarkGreaterThanOrEqualTo(String value) {
            addCriterion("full_mark >=", value, "fullMark");
            return (Criteria) this;
        }

        public Criteria andFullMarkLessThan(String value) {
            addCriterion("full_mark <", value, "fullMark");
            return (Criteria) this;
        }

        public Criteria andFullMarkLessThanOrEqualTo(String value) {
            addCriterion("full_mark <=", value, "fullMark");
            return (Criteria) this;
        }

        public Criteria andFullMarkLike(String value) {
            addCriterion("full_mark like", value, "fullMark");
            return (Criteria) this;
        }

        public Criteria andFullMarkNotLike(String value) {
            addCriterion("full_mark not like", value, "fullMark");
            return (Criteria) this;
        }

        public Criteria andFullMarkIn(List<String> values) {
            addCriterion("full_mark in", values, "fullMark");
            return (Criteria) this;
        }

        public Criteria andFullMarkNotIn(List<String> values) {
            addCriterion("full_mark not in", values, "fullMark");
            return (Criteria) this;
        }

        public Criteria andFullMarkBetween(String value1, String value2) {
            addCriterion("full_mark between", value1, value2, "fullMark");
            return (Criteria) this;
        }

        public Criteria andFullMarkNotBetween(String value1, String value2) {
            addCriterion("full_mark not between", value1, value2, "fullMark");
            return (Criteria) this;
        }


        public Criteria andDeptNameIsNull() {
            addCriterion("dept_name is null");
            return (Criteria) this;
        }

        public Criteria andDeptNameIsNotNull() {
            addCriterion("dept_name is not null");
            return (Criteria) this;
        }

        public Criteria andDeptNameEqualTo(String value) {
            addCriterion("dept_name =", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameNotEqualTo(String value) {
            addCriterion("dept_name <>", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameGreaterThan(String value) {
            addCriterion("dept_name >", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameGreaterThanOrEqualTo(String value) {
            addCriterion("dept_name >=", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameLessThan(String value) {
            addCriterion("dept_name <", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameLessThanOrEqualTo(String value) {
            addCriterion("dept_name <=", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameLike(String value) {
            addCriterion("dept_name like", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameNotLike(String value) {
            addCriterion("dept_name not like", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameIn(List<String> values) {
            addCriterion("dept_name in", values, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameNotIn(List<String> values) {
            addCriterion("dept_name not in", values, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameBetween(String value1, String value2) {
            addCriterion("dept_name between", value1, value2, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameNotBetween(String value1, String value2) {
            addCriterion("dept_name not between", value1, value2, "deptName");
            return (Criteria) this;
        }


        public Criteria andSupplyIdIsNull() {
            addCriterion("supply_id is null");
            return (Criteria) this;
        }

        public Criteria andSupplyIdIsNotNull() {
            addCriterion("supply_id is not null");
            return (Criteria) this;
        }

        public Criteria andSupplyIdEqualTo(String value) {
            addCriterion("supply_id =", value, "supplyId");
            return (Criteria) this;
        }

        public Criteria andSupplyIdNotEqualTo(String value) {
            addCriterion("supply_id <>", value, "supplyId");
            return (Criteria) this;
        }

        public Criteria andSupplyIdGreaterThan(String value) {
            addCriterion("supply_id >", value, "supplyId");
            return (Criteria) this;
        }

        public Criteria andSupplyIdGreaterThanOrEqualTo(String value) {
            addCriterion("supply_id >=", value, "supplyId");
            return (Criteria) this;
        }

        public Criteria andSupplyIdLessThan(String value) {
            addCriterion("supply_id <", value, "supplyId");
            return (Criteria) this;
        }

        public Criteria andSupplyIdLessThanOrEqualTo(String value) {
            addCriterion("supply_id <=", value, "supplyId");
            return (Criteria) this;
        }

        public Criteria andSupplyIdLike(String value) {
            addCriterion("supply_id like", value, "supplyId");
            return (Criteria) this;
        }

        public Criteria andSupplyIdNotLike(String value) {
            addCriterion("supply_id not like", value, "supplyId");
            return (Criteria) this;
        }

        public Criteria andSupplyIdIn(List<String> values) {
            addCriterion("supply_id in", values, "supplyId");
            return (Criteria) this;
        }

        public Criteria andSupplyIdNotIn(List<String> values) {
            addCriterion("supply_id not in", values, "supplyId");
            return (Criteria) this;
        }

        public Criteria andSupplyIdBetween(String value1, String value2) {
            addCriterion("supply_id between", value1, value2, "supplyId");
            return (Criteria) this;
        }

        public Criteria andSupplyIdNotBetween(String value1, String value2) {
            addCriterion("supply_id not between", value1, value2, "supplyId");
            return (Criteria) this;
        }


        public Criteria andSupplyNameIsNull() {
            addCriterion("supply_name is null");
            return (Criteria) this;
        }

        public Criteria andSupplyNameIsNotNull() {
            addCriterion("supply_name is not null");
            return (Criteria) this;
        }

        public Criteria andSupplyNameEqualTo(String value) {
            addCriterion("supply_name =", value, "supplyName");
            return (Criteria) this;
        }

        public Criteria andSupplyNameNotEqualTo(String value) {
            addCriterion("supply_name <>", value, "supplyName");
            return (Criteria) this;
        }

        public Criteria andSupplyNameGreaterThan(String value) {
            addCriterion("supply_name >", value, "supplyName");
            return (Criteria) this;
        }

        public Criteria andSupplyNameGreaterThanOrEqualTo(String value) {
            addCriterion("supply_name >=", value, "supplyName");
            return (Criteria) this;
        }

        public Criteria andSupplyNameLessThan(String value) {
            addCriterion("supply_name <", value, "supplyName");
            return (Criteria) this;
        }

        public Criteria andSupplyNameLessThanOrEqualTo(String value) {
            addCriterion("supply_name <=", value, "supplyName");
            return (Criteria) this;
        }

        public Criteria andSupplyNameLike(String value) {
            addCriterion("supply_name like", value, "supplyName");
            return (Criteria) this;
        }

        public Criteria andSupplyNameNotLike(String value) {
            addCriterion("supply_name not like", value, "supplyName");
            return (Criteria) this;
        }

        public Criteria andSupplyNameIn(List<String> values) {
            addCriterion("supply_name in", values, "supplyName");
            return (Criteria) this;
        }

        public Criteria andSupplyNameNotIn(List<String> values) {
            addCriterion("supply_name not in", values, "supplyName");
            return (Criteria) this;
        }

        public Criteria andSupplyNameBetween(String value1, String value2) {
            addCriterion("supply_name between", value1, value2, "supplyName");
            return (Criteria) this;
        }

        public Criteria andSupplyNameNotBetween(String value1, String value2) {
            addCriterion("supply_name not between", value1, value2, "supplyName");
            return (Criteria) this;
        }


        public Criteria andFkResultIdIsNull() {
            addCriterion("fk_result_id is null");
            return (Criteria) this;
        }

        public Criteria andFkResultIdIsNotNull() {
            addCriterion("fk_result_id is not null");
            return (Criteria) this;
        }

        public Criteria andFkResultIdEqualTo(String value) {
            addCriterion("fk_result_id =", value, "fkResultId");
            return (Criteria) this;
        }

        public Criteria andFkResultIdNotEqualTo(String value) {
            addCriterion("fk_result_id <>", value, "fkResultId");
            return (Criteria) this;
        }

        public Criteria andFkResultIdGreaterThan(String value) {
            addCriterion("fk_result_id >", value, "fkResultId");
            return (Criteria) this;
        }

        public Criteria andFkResultIdGreaterThanOrEqualTo(String value) {
            addCriterion("fk_result_id >=", value, "fkResultId");
            return (Criteria) this;
        }

        public Criteria andFkResultIdLessThan(String value) {
            addCriterion("fk_result_id <", value, "fkResultId");
            return (Criteria) this;
        }

        public Criteria andFkResultIdLessThanOrEqualTo(String value) {
            addCriterion("fk_result_id <=", value, "fkResultId");
            return (Criteria) this;
        }

        public Criteria andFkResultIdLike(String value) {
            addCriterion("fk_result_id like", value, "fkResultId");
            return (Criteria) this;
        }

        public Criteria andFkResultIdNotLike(String value) {
            addCriterion("fk_result_id not like", value, "fkResultId");
            return (Criteria) this;
        }

        public Criteria andFkResultIdIn(List<String> values) {
            addCriterion("fk_result_id in", values, "fkResultId");
            return (Criteria) this;
        }

        public Criteria andFkResultIdNotIn(List<String> values) {
            addCriterion("fk_result_id not in", values, "fkResultId");
            return (Criteria) this;
        }

        public Criteria andFkResultIdBetween(String value1, String value2) {
            addCriterion("fk_result_id between", value1, value2, "fkResultId");
            return (Criteria) this;
        }

        public Criteria andFkResultIdNotBetween(String value1, String value2) {
            addCriterion("fk_result_id not between", value1, value2, "fkResultId");
            return (Criteria) this;
        }


        public Criteria andLikeQuery(MonthResultDtl record) {
            List<String> list = new ArrayList<String>();
            List<String> list2 = new ArrayList<String>();
            StringBuffer buffer = new StringBuffer();
            if (record.getId() != null && StrUtil.isNotEmpty(record.getId().toString())) {
                list.add("ifnull(id,'')");
            }
            if (record.getFkTaskId() != null && StrUtil.isNotEmpty(record.getFkTaskId().toString())) {
                list.add("ifnull(fk_task_id,'')");
            }
            if (record.getTypeId() != null && StrUtil.isNotEmpty(record.getTypeId().toString())) {
                list.add("ifnull(type_id,'')");
            }
            if (record.getDeptId() != null && StrUtil.isNotEmpty(record.getDeptId().toString())) {
                list.add("ifnull(dept_id,'')");
            }
            if (record.getScore() != null && StrUtil.isNotEmpty(record.getScore().toString())) {
                list.add("ifnull(score,'')");
            }
            if (record.getFullMark() != null && StrUtil.isNotEmpty(record.getFullMark().toString())) {
                list.add("ifnull(full_mark,'')");
            }
            if (record.getDeptName() != null && StrUtil.isNotEmpty(record.getDeptName().toString())) {
                list.add("ifnull(dept_name,'')");
            }
            if (record.getSupplyId() != null && StrUtil.isNotEmpty(record.getSupplyId().toString())) {
                list.add("ifnull(supply_id,'')");
            }
            if (record.getSupplyName() != null && StrUtil.isNotEmpty(record.getSupplyName().toString())) {
                list.add("ifnull(supply_name,'')");
            }
            if (record.getFkResultId() != null && StrUtil.isNotEmpty(record.getFkResultId().toString())) {
                list.add("ifnull(fk_result_id,'')");
            }
            if (record.getId() != null && StrUtil.isNotEmpty(record.getId().toString())) {
                list2.add("'%" + record.getId() + "%'");
            }
            if (record.getFkTaskId() != null && StrUtil.isNotEmpty(record.getFkTaskId().toString())) {
                list2.add("'%" + record.getFkTaskId() + "%'");
            }
            if (record.getTypeId() != null && StrUtil.isNotEmpty(record.getTypeId().toString())) {
                list2.add("'%" + record.getTypeId() + "%'");
            }
            if (record.getDeptId() != null && StrUtil.isNotEmpty(record.getDeptId().toString())) {
                list2.add("'%" + record.getDeptId() + "%'");
            }
            if (record.getScore() != null && StrUtil.isNotEmpty(record.getScore().toString())) {
                list2.add("'%" + record.getScore() + "%'");
            }
            if (record.getFullMark() != null && StrUtil.isNotEmpty(record.getFullMark().toString())) {
                list2.add("'%" + record.getFullMark() + "%'");
            }
            if (record.getDeptName() != null && StrUtil.isNotEmpty(record.getDeptName().toString())) {
                list2.add("'%" + record.getDeptName() + "%'");
            }
            if (record.getSupplyId() != null && StrUtil.isNotEmpty(record.getSupplyId().toString())) {
                list2.add("'%" + record.getSupplyId() + "%'");
            }
            if (record.getSupplyName() != null && StrUtil.isNotEmpty(record.getSupplyName().toString())) {
                list2.add("'%" + record.getSupplyName() + "%'");
            }
            if (record.getFkResultId() != null && StrUtil.isNotEmpty(record.getFkResultId().toString())) {
                list2.add("'%" + record.getFkResultId() + "%'");
            }
            buffer.append(" CONCAT(");
            buffer.append(StrUtil.join(",", list));
            buffer.append(")");
            buffer.append(" like CONCAT(");
            buffer.append(StrUtil.join(",", list2));
            buffer.append(")");
            if (!" CONCAT() like CONCAT()".equals(buffer.toString())) {
                addCriterion(buffer.toString());
            }
            return (Criteria) this;
        }

        public Criteria andLikeQuery2(String searchText) {
            List<String> list = new ArrayList<String>();
            StringBuffer buffer = new StringBuffer();
            list.add("ifnull(id,'')");
            list.add("ifnull(fk_task_id,'')");
            list.add("ifnull(type_id,'')");
            list.add("ifnull(dept_id,'')");
            list.add("ifnull(score,'')");
            list.add("ifnull(full_mark,'')");
            list.add("ifnull(dept_name,'')");
            list.add("ifnull(supply_id,'')");
            list.add("ifnull(supply_name,'')");
            list.add("ifnull(fk_result_id,'')");
            buffer.append(" CONCAT(");
            buffer.append(StrUtil.join(",", list));
            buffer.append(")");
            buffer.append("like '%");
            buffer.append(searchText);
            buffer.append("%'");
            addCriterion(buffer.toString());
            return (Criteria) this;
        }

    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}